This course is designed to equip participants with the practical skills required to use Microsoft Excel more efficiently for workplace data tasks.

Participants will learn how to manage and analyse data using intermediate Excel tools such as tables, sorting, filtering, conditional formatting, data validation, formulas, functions, and charts. The course also introduces techniques for improving workbook structure, reducing manual work, and creating clearer reports for business use.

Through structured learning and practical examples, participants will gain the confidence to handle larger datasets, perform useful analysis, and prepare more effective Excel reports for daily operations.

This course is suitable for users who already understand basic Excel functions and want to improve their data management and reporting skills.

It is especially suitable for:

• Administrative staff
• Executives and officers
• Finance and accounting support staff
• HR and payroll teams
• Sales and operations teams
• Customer service teams
• Data entry and reporting staff
• Anyone who uses Excel regularly for workplace tasks

Participants should have basic experience using Microsoft Excel.

Before attending this course, participants are recommended to have:

• Ability to create, save, and manage Excel workbooks
• Familiarity with entering and formatting data
• Basic understanding of formulas and common functions such as SUM, AVERAGE, MIN, MAX, and COUNT
• Basic knowledge of sorting, filtering, and worksheet management
• Interest in improving spreadsheet accuracy, efficiency, and reporting

At the end of this course, participants will be able to:

• Manage and organise larger datasets using tables, sorting, filtering, and formatting tools
• Use intermediate formulas and functions to perform calculations and analysis
• Apply conditional formatting and data validation to improve spreadsheet accuracy
• Create charts and summaries for clearer data presentation
• Improve workbook structure and reporting efficiency for daily work

• Reviewing essential Excel skills and workbook management practices
• Working with tables, structured data, sorting, filtering, and removing duplicates
• Using intermediate formulas and functions such as IF, SUMIF, COUNTIF, VLOOKUP, XLOOKUP, and text functions
• Applying conditional formatting, data validation, and error-checking techniques
• Creating charts, summaries, and basic reports for data presentation
• Managing multiple worksheets, linking data, and improving workbook organisation
• Applying practical Excel techniques to improve workplace reporting and productivity